![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Reports Designer Reports Designer is the Developer/2000 tool for creating reports applications for the Windows, Macintosh, and Motif environments. The reporting tool can build graphical and printed forms easily and quickly and is very configurable. As with the Forms Designer, applications developed with the Oracle Reports Designer are typically fairly optimized. The actual query used in your report is defined as part of building the report. To modify this SQL statement, follow these steps:
Once you invoke the Query Editor, you can view or modify the SQL statement for optimal performance. By using the Query Editor, you can change your SQL statements to be more efficient. In this manner, you can completely optimize the application created by the Oracle Reports Designer tool.
You can examine the inputs to the report using the Data Model Editor (see Figure 35.5) to get a fairly good idea of the number of queries going into the report. By optimizing all of them, you can make the report very efficient.
It is entirely possible that there is no need to add additional optimization. However, by having the option to perform additional tuning and optimization on the SQL statements, you may be able to improve performance. Graphics Designer Graphics Designer is a tool for building graphical displays that can be used in a stand-alone fashion or in conjunction with the Oracle Forms Designer and Reports Designer. The Oracle Graphics Designer is similar to the Report Designer in that the creation of the query is part of the definition process. Because you are creating the query that will be used in the creation of the final chart, you have complete flexibility to optimize this query. The steps necessary to modify a query once the application has been written are as follows:
Once you invoke the Query Properties Editor, you can view or modify the SQL statement for optimal performance. By using the Query Properties Editor, you can change your SQL statements to be more efficient. In this manner, you can completely optimize the SQL statements used in the application created by the Oracle Graphics Designer tool. Procedure Builder The Oracle Procedure Builder is an integrated environment for editing, developing, and debugging PL/SQL programs, stored procedures, and database triggers. The Oracle Procedure Builder is integrated into the Developer/2000 suite of tools. The Procedure Builder does not create procedures or triggers for you; rather, it assists you in the development of those objects. As such, there is no type of optimization you can do to the Procedure Builder. The following options are available from the Procedure Builder to assist you in the development of these objects:
By using the PL/SQL interpreter, you have the ability to debug objects with the built-in debugging and tracing facilities. This can be useful for editing and obtaining information about stored programs in your database. The Database Trigger Editor allows you to view and modify the trigger body as well as change the trigger definitions. By using the various features included in the Procedure Builder (such as the development and debugging tools as well as the source-code control features), you can improve your productivity when developing applications.
Power ObjectsOracle Power Objects is relatively new and gaining in popularity. Power Objects is an application development tool that can work with your Oracle database or with a small stand-alone database that comes with it called BLAZE. Power Objects is object oriented and can have you developing small applications in a matter of minutes. Power Objects is very easy to use and powerful. By designing applications in an object-oriented fashion, you can easily reuse objects and save time. With Oracle Power Objects, you have the ability to build forms, reports, and classes. You can build on the classes, making Oracle Power Objects quite useful. As with all the tools described in this chapter, Power Objects uses a drag-and-drop interface, which makes all the tools easy to get started with. The following sections describe the three major areas of Power Objects development.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |